select * from products where pro_name like '%Spring%quinceaneras%dresses%' or pro_des like '%Spring%quinceaneras%dresses%'union all select * from products where (pro_name like '%Spring%' or pro_des like '%Spring%') or(pro_name like '%quinceaneras%' or pro_des like '%quinceaneras%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Spring%quinceaneras%dresses%' or pro_des not like '%Spring%quinceaneras%dresses%')

Taffeta Quinceanera Gown with Strapless Neck and Appliques

Spring Green A-line Quince Dress by Taffeta with Beading and Appliques

Olive Green Taffeta Sweet Sixteen Dresses with Beaded Bust and Layered Skirt

Limited Navy Blue and Black Strapless Quinceanera Gown Dress with Ruffled Skirt

Dark Green Quince Gown with Bodice by sequined Fabric and Ruffled Skirt

Yellow Quinceanera Dress by Taffeta and Organza with Beading and Ruffles

Yellow Green Organza Quinceanera Dress with Sweetheart Neck and Beading

2014 Purple Sweet Sixteen Quinceanera Dresses with Beading and Ruffles

Turquoise Quinceanera Dress with Sweetheart Neck and Leopard Print layers

Yellow Green Taffeta Strapless Dress For Quinceaneras with Black Embroidery

Teal Taffeta Quinceanera Gown with Sweetheart Neckline and Appliques

Turquoise and White Satin Quinceanera Dress with Embroidery and Appliques

Baby Blue Taffeta Quinceanera Gown with Spaghetti Straps and Appliques

Apple Green Quinceanera Dress by Taffeta with Beading and Pick-ups

Spring Green Strapless Quinceanera Gown dress by Organza with Pick-ups

Purple Strapless Quince Dress by Taffeta with Embroidery and Boning Details

Aqua Blue Sweetheart Quinceanera Gown Dress by Sequined Fabric for 2013

Strapless Sweet Sixteen Dresses by Organza with Appliques

Lavender Tulle Quince Dress with Ruched Bodice and A-Line / Princess Skirt

Strapless Sweet Sixteen Dresses by Tulle with Appliques

Spring Green Taffeta Quinceanera Dress with Embroidery and Beading

Spring Green Sweetheart Quinceanera Gowns with Ruches and Ruffled Skirt

Green and Pink One Shoulder Quince Dress with Beading and Ruffles

Multi-Color Quinceanera Dress with One Shoulder Neck and Ruffled Skirt

Purple and Pink A-Line / Princess Sweetheart Quinceanera Gown Dresses

Purple Strapless Quinceanera Dress by Taffeta with Appliques and Layers

Yellow Organza Quinceanera Gown with Strapless Neck and Beaded Top

Orange Sweetheart Organza Quinceanera Dress with Appliques and Ruffles

Purple and Fuchsia Sweet 16 Dresses with Spaghetti Straps and Ruffles

Teal A-Line / Princess Sweetheart Tulle Quinceanera Dress with Beading